Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	1103
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	149.8 KiB
Average record size in memory	139.1 B

Variable types

Numeric	13
Categorical	4
Boolean	3

Alerts

`realSum` is highly overall correlated with `bedrooms`	High correlation
`cleanliness_rating` is highly overall correlated with `guest_satisfaction_overall`	High correlation
`guest_satisfaction_overall` is highly overall correlated with `cleanliness_rating`	High correlation
`bedrooms` is highly overall correlated with `realSum`	High correlation
`dist` is highly overall correlated with `attr_index` and 3 other fields	High correlation
`attr_index` is highly overall correlated with `dist` and 3 other fields	High correlation
`attr_index_norm` is highly overall correlated with `dist` and 3 other fields	High correlation
`rest_index` is highly overall correlated with `dist` and 3 other fields	High correlation
`rest_index_norm` is highly overall correlated with `dist` and 3 other fields	High correlation
`room_type` is highly overall correlated with `room_shared` and 1 other fields	High correlation
`room_shared` is highly overall correlated with `room_type`	High correlation
`room_private` is highly overall correlated with `room_type`	High correlation
`room_shared` is highly imbalanced (95.1%)	Imbalance
`Unnamed: 0` is uniformly distributed	Uniform
`Unnamed: 0` has unique values	Unique
`dist` has unique values	Unique
`metro_dist` has unique values	Unique
`attr_index` has unique values	Unique
`attr_index_norm` has unique values	Unique
`rest_index` has unique values	Unique
`rest_index_norm` has unique values	Unique
`bedrooms` has 83 (7.5%) zeros	Zeros

Reproduction

Analysis started	2023-08-11 15:53:47.688010
Analysis finished	2023-08-11 15:54:25.538422
Duration	37.85 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

Unnamed: 0
Real number (ℝ)

UNIFORM UNIQUE

Distinct	1103
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	551

Minimum	0
Maximum	1102
Zeros	1
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	8.7 KiB

Quantile statistics

Minimum	0
5-th percentile	55.1
Q1	275.5
median	551
Q3	826.5
95-th percentile	1046.9
Maximum	1102
Range	1102
Interquartile range (IQR)	551

Descriptive statistics

Standard deviation	318.55298
Coefficient of variation (CV)	0.57813608
Kurtosis	-1.2
Mean	551
Median Absolute Deviation (MAD)	276
Skewness	0
Sum	607753
Variance	101476
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	0.1%
733	1	0.1%
739	1	0.1%
738	1	0.1%
737	1	0.1%
736	1	0.1%
735	1	0.1%
734	1	0.1%
732	1	0.1%
758	1	0.1%
Other values (1093)	1093	99.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	0.1%
1	1	0.1%
2	1	0.1%
3	1	0.1%
4	1	0.1%
5	1	0.1%
6	1	0.1%
7	1	0.1%
8	1	0.1%
9	1	0.1%

Value	Count	Frequency (%)
1102	1	0.1%
1101	1	0.1%
1100	1	0.1%
1099	1	0.1%
1098	1	0.1%
1097	1	0.1%
1096	1	0.1%
1095	1	0.1%
1094	1	0.1%
1093	1	0.1%

realSum
Real number (ℝ)

Distinct	534
Distinct (%)	48.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	545.02053

Minimum	128.88712
Maximum	7782.9072
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.7 KiB

Quantile statistics

Minimum	128.88712
5-th percentile	210.57812
Q1	309.79776
median	430.24863
Q3	657.3243
95-th percentile	1178.4266
Maximum	7782.9072
Range	7654.0201
Interquartile range (IQR)	347.52654

Descriptive statistics

Standard deviation	416.97431
Coefficient of variation (CV)	0.76506167
Kurtosis	88.040199
Mean	545.02053
Median Absolute Deviation (MAD)	150.21208
Skewness	6.432379
Sum	601157.64
Variance	173867.58
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
614.4400441	15	1.4%
307.220022	11	1.0%
393.4572212	11	1.0%
196.6114405	11	1.0%
209.0314719	10	0.9%
552.8085675	10	0.9%
467.0400487	10	0.9%
319.6400534	10	0.9%
737.2343168	9	0.8%
504.0658027	9	0.8%
Other values (524)	997	90.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
128.8871183	1	0.1%
143.6505519	1	0.1%
144.8222529	2	0.2%
161.9290887	1	0.1%
165.6785321	1	0.1%
167.3189136	1	0.1%
175.7551613	1	0.1%
177.1612026	2	0.2%
178.0985635	1	0.1%
180.2076254	1	0.1%

Value	Count	Frequency (%)
7782.907225	1	0.1%
3637.663159	1	0.1%
3004.944579	1	0.1%
2771.307384	1	0.1%
2556.183067	1	0.1%
2500.878776	1	0.1%
2486.115342	1	0.1%
2458.228857	1	0.1%
2061.959553	1	0.1%
2058.210109	1	0.1%

room_type
Categorical

Distinct	3
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	8.7 KiB

Private room	559
Entire home/apt	538
Shared room	6

Length

Max length	15
Median length	12
Mean length	13.457842
Min length	11

Characters and Unicode

Total characters	14844
Distinct characters	17
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Private room
2nd row	Private room
3rd row	Private room
4th row	Private room
5th row	Private room

Common Values

Value	Count	Frequency (%)
Private room	559	50.7%
Entire home/apt	538	48.8%
Shared room	6	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
room	565	25.6%
private	559	25.3%
entire	538	24.4%
home/apt	538	24.4%
shared	6	0.3%

Most occurring characters

Value	Count	Frequency (%)
o	1668	11.2%
r	1668	11.2%
e	1641	11.1%
t	1635	11.0%
m	1103	7.4%
a	1103	7.4%
	1103	7.4%
i	1097	7.4%
P	559	3.8%
v	559	3.8%
Other values (7)	2708	18.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	12100	81.5%
Space Separator	1103	7.4%
Uppercase Letter	1103	7.4%
Other Punctuation	538	3.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	1668	13.8%
r	1668	13.8%
e	1641	13.6%
t	1635	13.5%
m	1103	9.1%
a	1103	9.1%
i	1097	9.1%
v	559	4.6%
h	544	4.5%
n	538	4.4%
Other values (2)	544	4.5%

Uppercase Letter

Value	Count	Frequency (%)
P	559	50.7%
E	538	48.8%
S	6	0.5%

Space Separator

Value	Count	Frequency (%)
	1103	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	538	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	13203	88.9%
Common	1641	11.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	1668	12.6%
r	1668	12.6%
e	1641	12.4%
t	1635	12.4%
m	1103	8.4%
a	1103	8.4%
i	1097	8.3%
P	559	4.2%
v	559	4.2%
h	544	4.1%
Other values (5)	1626	12.3%

Common

Value	Count	Frequency (%)
	1103	67.2%
/	538	32.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14844	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	1668	11.2%
r	1668	11.2%
e	1641	11.1%
t	1635	11.0%
m	1103	7.4%
a	1103	7.4%
	1103	7.4%
i	1097	7.4%
P	559	3.8%
v	559	3.8%
Other values (7)	2708	18.2%

room_shared
Boolean

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1.2 KiB

False	1097
True	6

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1097	99.5%
True	6	0.5%

room_private
Boolean

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1.2 KiB

True	559
False	544

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	559	50.7%
False	544	49.3%

person_capacity
Categorical

Distinct	5
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	8.7 KiB

2.0	656
4.0	333
3.0	79
6.0	24
5.0	11

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	3309
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2.0
2nd row	4.0
3rd row	2.0
4th row	4.0
5th row	2.0

Common Values

Value	Count	Frequency (%)
2.0	656	59.5%
4.0	333	30.2%
3.0	79	7.2%
6.0	24	2.2%
5.0	11	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2.0	656	59.5%
4.0	333	30.2%
3.0	79	7.2%
6.0	24	2.2%
5.0	11	1.0%

Most occurring characters

Value	Count	Frequency (%)
.	1103	33.3%
0	1103	33.3%
2	656	19.8%
4	333	10.1%
3	79	2.4%
6	24	0.7%
5	11	0.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2206	66.7%
Other Punctuation	1103	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1103	50.0%
2	656	29.7%
4	333	15.1%
3	79	3.6%
6	24	1.1%
5	11	0.5%

Other Punctuation

Value	Count	Frequency (%)
.	1103	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3309	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	1103	33.3%
0	1103	33.3%
2	656	19.8%
4	333	10.1%
3	79	2.4%
6	24	0.7%
5	11	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3309	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	1103	33.3%
0	1103	33.3%
2	656	19.8%
4	333	10.1%
3	79	2.4%
6	24	0.7%
5	11	0.3%

host_is_superhost
Boolean

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1.2 KiB

False	780
True	323

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	780	70.7%
True	323	29.3%

multi
Categorical

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	8.7 KiB

0	763
1	340

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1103
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	763	69.2%
1	340	30.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	763	69.2%
1	340	30.8%

Most occurring characters

Value	Count	Frequency (%)
0	763	69.2%
1	340	30.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1103	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	763	69.2%
1	340	30.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	1103	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	763	69.2%
1	340	30.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1103	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	763	69.2%
1	340	30.8%

biz
Categorical

Distinct	2
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	8.7 KiB

0	976
1	127

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1103
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
0	976	88.5%
1	127	11.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	976	88.5%
1	127	11.5%

Most occurring characters

Value	Count	Frequency (%)
0	976	88.5%
1	127	11.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1103	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	976	88.5%
1	127	11.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	1103	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	976	88.5%
1	127	11.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1103	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	976	88.5%
1	127	11.5%

cleanliness_rating
Real number (ℝ)

Distinct	7
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.4614687

Minimum	4
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.7 KiB

Quantile statistics

Minimum	4
5-th percentile	8
Q1	9
median	10
Q3	10
95-th percentile	10
Maximum	10
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.79820148
Coefficient of variation (CV)	0.08436338
Kurtosis	6.7442662
Mean	9.4614687
Median Absolute Deviation (MAD)	0
Skewness	-2.0618151
Sum	10436
Variance	0.63712561
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
10	659	59.7%
9	334	30.3%
8	87	7.9%
7	11	1.0%
6	9	0.8%
4	2	0.2%
5	1	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4	2	0.2%
5	1	0.1%
6	9	0.8%
7	11	1.0%
8	87	7.9%
9	334	30.3%
10	659	59.7%

Value	Count	Frequency (%)
10	659	59.7%
9	334	30.3%
8	87	7.9%
7	11	1.0%
6	9	0.8%
5	1	0.1%
4	2	0.2%

guest_satisfaction_overall
Real number (ℝ)

Distinct	32
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	94.362647

Minimum	20
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.7 KiB

Quantile statistics

Minimum	20
5-th percentile	84
Q1	92
median	96
Q3	98
95-th percentile	100
Maximum	100
Range	80
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	6.0896912
Coefficient of variation (CV)	0.064534976
Kurtosis	26.18274
Mean	94.362647
Median Absolute Deviation (MAD)	3
Skewness	-3.383583
Sum	104082
Variance	37.084339
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
100	190	17.2%
98	122	11.1%
96	121	11.0%
97	95	8.6%
95	82	7.4%
94	69	6.3%
93	67	6.1%
99	65	5.9%
90	51	4.6%
92	48	4.4%
Other values (22)	193	17.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20	1	0.1%
47	1	0.1%
60	3	0.3%
65	1	0.1%
70	1	0.1%
73	1	0.1%
74	1	0.1%
75	2	0.2%
76	1	0.1%
77	1	0.1%

Value	Count	Frequency (%)
100	190	17.2%
99	65	5.9%
98	122	11.1%
97	95	8.6%
96	121	11.0%
95	82	7.4%
94	69	6.3%
93	67	6.1%
92	48	4.4%
91	30	2.7%

bedrooms
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	6
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.2828649

Minimum	0
Maximum	5
Zeros	83
Zeros (%)	7.5%
Negative	0
Negative (%)	0.0%
Memory size	8.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	2
95-th percentile	3
Maximum	5
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.74017837
Coefficient of variation (CV)	0.57697296
Kurtosis	2.1404905
Mean	1.2828649
Median Absolute Deviation (MAD)	0
Skewness	1.1359222
Sum	1415
Variance	0.54786402
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	719	65.2%
2	218	19.8%
0	83	7.5%
3	74	6.7%
4	7	0.6%
5	2	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	83	7.5%
1	719	65.2%
2	218	19.8%
3	74	6.7%
4	7	0.6%
5	2	0.2%

Value	Count	Frequency (%)
5	2	0.2%
4	7	0.6%
3	74	6.7%
2	218	19.8%
1	719	65.2%
0	83	7.5%

dist
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	1103
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.8416213

Minimum	0.015058798
Maximum	11.1871
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.7 KiB

Quantile statistics

Minimum	0.015058798
5-th percentile	0.42700018
Q1	1.3020583
median	2.3413656
Q3	3.6481385
95-th percentile	7.443446
Maximum	11.1871
Range	11.172041
Interquartile range (IQR)	2.3460802

Descriptive statistics

Standard deviation	2.1232449
Coefficient of variation (CV)	0.74719487
Kurtosis	2.2768627
Mean	2.8416213
Median Absolute Deviation (MAD)	1.1738733
Skewness	1.4569638
Sum	3134.3083
Variance	4.5081688
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.022963798	1	0.1%
1.908567063	1	0.1%
4.486620645	1	0.1%
8.436536017	1	0.1%
1.729196947	1	0.1%
2.091818702	1	0.1%
0.4099399981	1	0.1%
6.842851866	1	0.1%
1.31950798	1	0.1%
2.325287056	1	0.1%
Other values (1093)	1093	99.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01505879807	1	0.1%
0.09965350127	1	0.1%
0.1148056768	1	0.1%
0.1228203248	1	0.1%
0.1386645584	1	0.1%
0.1613319628	1	0.1%
0.1673131478	1	0.1%
0.1757999097	1	0.1%
0.1847578359	1	0.1%
0.1885288279	1	0.1%

Value	Count	Frequency (%)
11.18710015	1	0.1%
11.03804499	1	0.1%
11.03773604	1	0.1%
10.96723627	1	0.1%
10.89864664	1	0.1%
10.85349274	1	0.1%
10.72982971	1	0.1%
10.72348325	1	0.1%
10.48852457	1	0.1%
10.45321955	1	0.1%

metro_dist
Real number (ℝ)

Distinct	1103
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.0894387

Minimum	0.036529935
Maximum	4.4119153
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.7 KiB

Quantile statistics

Minimum	0.036529935
5-th percentile	0.19378681
Q1	0.46298277
median	0.85600979
Q3	1.5106295
95-th percentile	2.9073901
Maximum	4.4119153
Range	4.3753854
Interquartile range (IQR)	1.0476467

Descriptive statistics

Standard deviation	0.83654649
Coefficient of variation (CV)	0.76786929
Kurtosis	1.8106196
Mean	1.0894387
Median Absolute Deviation (MAD)	0.47180533
Skewness	1.3692336
Sum	1201.6508
Variance	0.69981002
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.539380003	1	0.1%
0.6992974213	1	0.1%
0.7057572605	1	0.1%
4.030013942	1	0.1%
0.4963551695	1	0.1%
1.517031912	1	0.1%
0.2774761465	1	0.1%
2.249047727	1	0.1%
1.233194724	1	0.1%
1.499233818	1	0.1%
Other values (1093)	1093	99.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.03652993497	1	0.1%
0.0383546937	1	0.1%
0.04522023671	1	0.1%
0.0484628245	1	0.1%
0.05105210307	1	0.1%
0.05493078887	1	0.1%
0.05679341113	1	0.1%
0.05689155184	1	0.1%
0.05769814365	1	0.1%
0.06871843184	1	0.1%

Value	Count	Frequency (%)
4.411915315	1	0.1%
4.143226904	1	0.1%
4.135221094	1	0.1%
4.095711512	1	0.1%
4.030013942	1	0.1%
3.95047039	1	0.1%
3.946521658	1	0.1%
3.929398124	1	0.1%
3.911722316	1	0.1%
3.882222537	1	0.1%

attr_index
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	1103
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	271.0099

Minimum	40.931415
Maximum	1888.5504
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.7 KiB

Quantile statistics

Minimum	40.931415
5-th percentile	61.533722
Q1	127.90987
median	208.18031
Q3	386.44224
95-th percentile	599.62869
Maximum	1888.5504
Range	1847.619
Interquartile range (IQR)	258.53238

Descriptive statistics

Standard deviation	197.04689
Coefficient of variation (CV)	0.72708374
Kurtosis	9.6690992
Mean	271.0099
Median Absolute Deviation (MAD)	106.48261
Skewness	2.057118
Sum	298923.92
Variance	38827.477
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
78.69037927	1	0.1%
312.7830516	1	0.1%
106.6760639	1	0.1%
54.92704857	1	0.1%
389.7122247	1	0.1%
322.3916213	1	0.1%
532.1488235	1	0.1%
69.38420307	1	0.1%
344.1277961	1	0.1%
181.5168762	1	0.1%
Other values (1093)	1093	99.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
40.93141537	1	0.1%
41.27584675	1	0.1%
41.34581474	1	0.1%
41.64218464	1	0.1%
42.01023157	1	0.1%
42.02512119	1	0.1%
42.64524544	1	0.1%
42.9510542	1	0.1%
43.90667928	1	0.1%
44.05838787	1	0.1%

Value	Count	Frequency (%)
1888.550428	1	0.1%
1861.001507	1	0.1%
1502.553669	1	0.1%
1238.466777	1	0.1%
1171.698732	1	0.1%
1030.28114	1	0.1%
1029.727093	1	0.1%
1003.308116	1	0.1%
996.1632313	1	0.1%
843.9920247	1	0.1%

attr_index_norm
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	1103
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.350154

Minimum	2.1673456
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.7 KiB

Quantile statistics

Minimum	2.1673456
5-th percentile	3.2582514
Q1	6.7729124
median	11.023286
Q3	20.462373
95-th percentile	31.750738
Maximum	100
Range	97.832654
Interquartile range (IQR)	13.689461

Descriptive statistics

Standard deviation	10.433764
Coefficient of variation (CV)	0.72708374
Kurtosis	9.6690992
Mean	14.350154
Median Absolute Deviation (MAD)	5.6383252
Skewness	2.057118
Sum	15828.22
Variance	108.86343
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.166707868	1	0.1%
16.56207041	1	0.1%
5.648568465	1	0.1%
2.908423718	1	0.1%
20.63552124	1	0.1%
17.07085056	1	0.1%
28.17763379	1	0.1%
3.673939655	1	0.1%
18.22179546	1	0.1%
9.611439203	1	0.1%
Other values (1093)	1093	99.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.167345641	1	0.1%
2.185583511	1	0.1%
2.189288363	1	0.1%
2.204981346	1	0.1%
2.224469675	1	0.1%
2.225258091	1	0.1%
2.258094082	1	0.1%
2.274286859	1	0.1%
2.324887842	1	0.1%
2.332920912	1	0.1%

Value	Count	Frequency (%)
100	1	0.1%
98.54126635	1	0.1%
79.56121514	1	0.1%
65.57763876	1	0.1%
62.0422264	1	0.1%
54.55407092	1	0.1%
54.5247338	1	0.1%
53.12583138	1	0.1%
52.747505	1	0.1%
44.6899385	1	0.1%

rest_index
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	1103
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	341.54119

Minimum	50.877318
Maximum	1435.1024
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.7 KiB

Quantile statistics

Minimum	50.877318
5-th percentile	76.7461
Q1	163.46925
median	260.25703
Q3	469.29062
95-th percentile	823.21913
Maximum	1435.1024
Range	1384.2251
Interquartile range (IQR)	305.82138

Descriptive statistics

Standard deviation	236.61108
Coefficient of variation (CV)	0.69277465
Kurtosis	0.58047537
Mean	341.54119
Median Absolute Deviation (MAD)	131.65548
Skewness	1.0590337
Sum	376719.93
Variance	55984.802
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
98.25389587	1	0.1%
424.8028021	1	0.1%
132.1598902	1	0.1%
67.75326378	1	0.1%
432.2252507	1	0.1%
342.1987911	1	0.1%
718.0178209	1	0.1%
85.84094839	1	0.1%
450.7620228	1	0.1%
225.6820037	1	0.1%
Other values (1093)	1093	99.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
50.87731805	1	0.1%
51.29423178	1	0.1%
51.38730756	1	0.1%
51.79848967	1	0.1%
52.24171152	1	0.1%
52.24369565	1	0.1%
53.03613817	1	0.1%
53.51539664	1	0.1%
54.66234758	1	0.1%
54.83772631	1	0.1%

Value	Count	Frequency (%)
1435.102401	1	0.1%
1402.15391	1	0.1%
1147.147422	1	0.1%
1144.936404	1	0.1%
1077.008769	1	0.1%
1044.506889	1	0.1%
1023.904785	1	0.1%
1022.004125	1	0.1%
994.770135	1	0.1%
969.6423035	1	0.1%

rest_index_norm
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	1103
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.799081

Minimum	3.5452047
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.7 KiB

Quantile statistics

Minimum	3.5452047
5-th percentile	5.3477787
Q1	11.390772
median	18.135084
Q3	32.700846
95-th percentile	57.363093
Maximum	100
Range	96.454795
Interquartile range (IQR)	21.310074

Descriptive statistics

Standard deviation	16.4874
Coefficient of variation (CV)	0.69277465
Kurtosis	0.58047537
Mean	23.799081
Median Absolute Deviation (MAD)	9.1739434
Skewness	1.0590337
Sum	26250.387
Variance	271.83437
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.846472824	1	0.1%
29.60087042	1	0.1%
9.209091291	1	0.1%
4.721144898	1	0.1%
30.11807732	1	0.1%
23.84490409	1	0.1%
50.03251479	1	0.1%
5.981520785	1	0.1%
31.40974627	1	0.1%
15.72584671	1	0.1%
Other values (1093)	1093	99.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.54520472	1	0.1%
3.574255869	1	0.1%
3.580741523	1	0.1%
3.609393284	1	0.1%
3.64027762	1	0.1%
3.640415877	1	0.1%
3.695634412	1	0.1%
3.729029831	1	0.1%
3.808951023	1	0.1%
3.821171665	1	0.1%

Value	Count	Frequency (%)
100	1	0.1%
97.70410177	1	0.1%
79.93488282	1	0.1%
79.78081586	1	0.1%
75.04752053	1	0.1%
72.7827428	1	0.1%
71.34715853	1	0.1%
71.21471779	1	0.1%
69.3170142	1	0.1%
67.56607076	1	0.1%

lng
Real number (ℝ)

Distinct	1022
Distinct (%)	92.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.8911576

Minimum	4.7755
Maximum	5.01077
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.7 KiB

Quantile statistics

Minimum	4.7755
5-th percentile	4.829621
Q1	4.871
median	4.89001
Q3	4.907315
95-th percentile	4.968632
Maximum	5.01077
Range	0.23527
Interquartile range (IQR)	0.036315

Descriptive statistics

Standard deviation	0.038882079
Coefficient of variation (CV)	0.0079494636
Kurtosis	1.180797
Mean	4.8911576
Median Absolute Deviation (MAD)	0.01801
Skewness	0.32041189
Sum	5394.9468
Variance	0.0015118161
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.91	6	0.5%
4.895	4	0.4%
4.88971	3	0.3%
4.896	3	0.3%
4.946	3	0.3%
4.874	3	0.3%
4.893	3	0.3%
4.90369	3	0.3%
4.878	3	0.3%
4.875	3	0.3%
Other values (1012)	1069	96.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4.7755	1	0.1%
4.77975	1	0.1%
4.78027	1	0.1%
4.78534	1	0.1%
4.78555	1	0.1%
4.78591	1	0.1%
4.78696	1	0.1%
4.78922	1	0.1%
4.78942	1	0.1%
4.78951	1	0.1%

Value	Count	Frequency (%)
5.01077	1	0.1%
5.00974	1	0.1%
5.00769	1	0.1%
5.00683	1	0.1%
5.00633	1	0.1%
5.0049	1	0.1%
5.00369	1	0.1%
5.00232	1	0.1%
5.0021	1	0.1%
5.00072	1	0.1%

lat
Real number (ℝ)

Distinct	950
Distinct (%)	86.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.364858

Minimum	52.2911
Maximum	52.42348
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.7 KiB

Quantile statistics

Minimum	52.2911
5-th percentile	52.332222
Q1	52.35458
median	52.36559
Q3	52.37526
95-th percentile	52.395936
Maximum	52.42348
Range	0.13238
Interquartile range (IQR)	0.02068

Descriptive statistics

Standard deviation	0.019467444
Coefficient of variation (CV)	0.00037176542
Kurtosis	2.1350288
Mean	52.364858
Median Absolute Deviation (MAD)	0.01046
Skewness	-0.47546214
Sum	57758.438
Variance	0.00037898136
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
52.362	5	0.5%
52.365	4	0.4%
52.373	4	0.4%
52.37062	4	0.4%
52.394	4	0.4%
52.36	4	0.4%
52.366	3	0.3%
52.364	3	0.3%
52.37075	3	0.3%
52.36376	3	0.3%
Other values (940)	1066	96.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
52.2911	1	0.1%
52.2915	1	0.1%
52.29304	1	0.1%
52.29306	1	0.1%
52.2963	1	0.1%
52.2972	1	0.1%
52.2977	1	0.1%
52.29838	1	0.1%
52.29921	1	0.1%
52.29924	1	0.1%

Value	Count	Frequency (%)
52.42348	1	0.1%
52.42343	1	0.1%
52.42337	1	0.1%
52.42258	1	0.1%
52.42006	1	0.1%
52.419	1	0.1%
52.4185	1	0.1%
52.41772	1	0.1%
52.41746	1	0.1%
52.41659	1	0.1%

Auto

Heatmap
Table

	Unnamed: 0	realSum	cleanliness_rating	guest_satisfaction_overall	bedrooms	dist	metro_dist	attr_index	attr_index_norm	rest_index	rest_index_norm	lng	lat	room_type	room_shared	room_private	person_capacity	host_is_superhost	multi	biz
Unnamed: 0	1.000	-0.034	-0.007	0.015	-0.010	0.028	0.030	-0.021	-0.021	-0.027	-0.027	-0.036	-0.040	0.005	0.000	0.042	0.000	0.027	0.054	0.165
realSum	-0.034	1.000	-0.003	0.175	0.523	-0.390	-0.193	0.410	0.410	0.400	0.400	-0.045	0.084	0.216	0.000	0.309	0.244	0.000	0.059	0.000
cleanliness_rating	-0.007	-0.003	1.000	0.571	-0.022	-0.006	0.001	0.001	0.001	0.003	0.003	-0.039	0.003	0.016	0.000	0.032	0.024	0.343	0.000	0.067
guest_satisfaction_overall	0.015	0.175	0.571	1.000	0.131	0.011	0.060	-0.016	-0.016	-0.015	-0.015	-0.063	0.026	0.048	0.000	0.094	0.000	0.327	0.000	0.130
bedrooms	-0.010	0.523	-0.022	0.131	1.000	0.056	0.014	-0.040	-0.040	-0.049	-0.049	-0.025	-0.033	0.311	0.000	0.437	0.391	0.099	0.119	0.125
dist	0.028	-0.390	-0.006	0.011	0.056	1.000	0.401	-0.951	-0.951	-0.961	-0.961	0.037	-0.407	0.187	0.116	0.236	0.000	0.097	0.070	0.139
metro_dist	0.030	-0.193	0.001	0.060	0.014	0.401	1.000	-0.488	-0.488	-0.483	-0.483	-0.161	0.248	0.081	0.000	0.115	0.000	0.000	0.000	0.154
attr_index	-0.021	0.410	0.001	-0.016	-0.040	-0.951	-0.488	1.000	1.000	0.989	0.989	-0.088	0.206	0.000	0.000	0.056	0.000	0.000	0.000	0.138
attr_index_norm	-0.021	0.410	0.001	-0.016	-0.040	-0.951	-0.488	1.000	1.000	0.989	0.989	-0.088	0.206	0.000	0.000	0.056	0.000	0.000	0.000	0.138
rest_index	-0.027	0.400	0.003	-0.015	-0.049	-0.961	-0.483	0.989	0.989	1.000	1.000	-0.082	0.219	0.116	0.000	0.175	0.000	0.000	0.085	0.165
rest_index_norm	-0.027	0.400	0.003	-0.015	-0.049	-0.961	-0.483	0.989	0.989	1.000	1.000	-0.082	0.219	0.116	0.000	0.175	0.000	0.000	0.085	0.165
lng	-0.036	-0.045	-0.039	-0.063	-0.025	0.037	-0.161	-0.088	-0.088	-0.082	-0.082	1.000	-0.087	0.123	0.067	0.157	0.045	0.024	0.108	0.127
lat	-0.040	0.084	0.003	0.026	-0.033	-0.407	0.248	0.206	0.206	0.219	0.219	-0.087	1.000	0.112	0.073	0.140	0.000	0.000	0.000	0.075
room_type	0.005	0.216	0.016	0.048	0.311	0.187	0.081	0.000	0.000	0.116	0.116	0.123	0.112	1.000	1.000	1.000	0.268	0.168	0.240	0.074
room_shared	0.000	0.000	0.000	0.000	0.000	0.116	0.000	0.000	0.000	0.000	0.000	0.067	0.073	1.000	1.000	0.055	0.047	0.000	0.000	0.000
room_private	0.042	0.309	0.032	0.094	0.437	0.236	0.115	0.056	0.056	0.175	0.175	0.157	0.140	1.000	0.055	1.000	0.374	0.168	0.235	0.074
person_capacity	0.000	0.244	0.024	0.000	0.391	0.000	0.000	0.000	0.000	0.000	0.000	0.045	0.000	0.268	0.047	0.374	1.000	0.082	0.154	0.092
host_is_superhost	0.027	0.000	0.343	0.327	0.099	0.097	0.000	0.000	0.000	0.000	0.000	0.024	0.000	0.168	0.000	0.168	0.082	1.000	0.090	0.132
multi	0.054	0.059	0.000	0.000	0.119	0.070	0.000	0.000	0.000	0.085	0.085	0.108	0.000	0.240	0.000	0.235	0.154	0.090	1.000	0.236
biz	0.165	0.000	0.067	0.130	0.125	0.139	0.154	0.138	0.138	0.165	0.165	0.127	0.075	0.074	0.000	0.074	0.092	0.132	0.236	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Unnamed: 0	realSum	room_type	room_shared	room_private	person_capacity	host_is_superhost	multi	biz	cleanliness_rating	guest_satisfaction_overall	bedrooms	dist	metro_dist	attr_index	attr_index_norm	rest_index	rest_index_norm	lng	lat
0	0	194.033698	Private room	False	True	2.0	False	1	0	10.0	93.0	1	5.022964	2.539380	78.690379	4.166708	98.253896	6.846473	4.90569	52.41772
1	1	344.245776	Private room	False	True	4.0	False	0	0	8.0	85.0	1	0.488389	0.239404	631.176378	33.421209	837.280757	58.342928	4.90005	52.37432
2	2	264.101422	Private room	False	True	2.0	False	0	1	9.0	87.0	1	5.748312	3.651621	75.275877	3.985908	95.386955	6.646700	4.97512	52.36103
3	3	433.529398	Private room	False	True	4.0	False	0	1	9.0	90.0	2	0.384862	0.439876	493.272534	26.119108	875.033098	60.973565	4.89417	52.37663
4	4	485.552926	Private room	False	True	2.0	True	0	0	10.0	98.0	1	0.544738	0.318693	552.830324	29.272733	815.305740	56.811677	4.90051	52.37508
5	5	552.808567	Private room	False	True	3.0	False	0	0	8.0	100.0	2	2.131420	1.904668	174.788957	9.255191	225.201662	15.692376	4.87699	52.38966
6	6	215.124317	Private room	False	True	2.0	False	0	0	10.0	94.0	1	1.881092	0.729747	200.167652	10.599010	242.765524	16.916251	4.91570	52.38296
7	7	2771.307384	Entire home/apt	False	False	4.0	True	0	0	10.0	100.0	3	1.686807	1.458404	208.808109	11.056528	272.313823	18.975219	4.88467	52.38749
8	8	1001.804420	Entire home/apt	False	False	4.0	False	0	0	9.0	96.0	2	3.719141	1.196112	106.226456	5.624761	133.876202	9.328686	4.86459	52.40175
9	9	276.521454	Private room	False	True	2.0	False	1	0	10.0	88.0	1	3.142361	0.924404	206.252862	10.921226	238.291258	16.604478	4.87600	52.34700

	Unnamed: 0	realSum	room_type	room_shared	room_private	person_capacity	host_is_superhost	multi	biz	cleanliness_rating	guest_satisfaction_overall	bedrooms	dist	metro_dist	attr_index	attr_index_norm	rest_index	rest_index_norm	lng	lat
1093	1093	909.474375	Entire home/apt	False	False	4.0	False	0	0	8.0	86.0	2	2.135919	0.256965	405.486553	21.470782	460.676738	32.100618	4.88701	52.35440
1094	1094	228.716050	Private room	False	True	3.0	True	0	0	10.0	98.0	1	7.628766	2.927773	61.792169	3.271936	76.466601	5.328303	4.79162	52.34422
1095	1095	378.693788	Entire home/apt	False	False	2.0	False	0	0	9.0	83.0	1	3.326725	1.330570	181.298148	9.599857	216.228585	15.067119	4.86162	52.35037
1096	1096	295.034331	Private room	False	True	2.0	False	0	1	8.0	86.0	1	4.880430	0.884337	107.334737	5.683446	132.699137	9.246667	4.84422	52.34116
1097	1097	356.197127	Private room	False	True	4.0	True	0	0	10.0	95.0	1	2.169253	0.212113	224.433556	11.883906	291.785726	20.332049	4.91118	52.35718
1098	1098	2486.115342	Entire home/apt	False	False	2.0	False	0	0	10.0	100.0	1	2.375833	1.436054	181.198355	9.594573	225.304203	15.699521	4.85869	52.37677
1099	1099	233.637194	Private room	False	True	2.0	False	1	0	10.0	90.0	1	4.719736	0.322263	108.024880	5.719989	134.775277	9.391335	4.83611	52.34910
1100	1100	317.062311	Private room	False	True	2.0	False	1	0	10.0	92.0	1	0.598355	0.751993	440.476515	23.323524	625.947562	43.616927	4.88897	52.37798
1101	1101	1812.855904	Entire home/apt	False	False	4.0	False	0	0	8.0	84.0	5	1.943020	0.388532	257.948105	13.658524	336.589237	23.454022	4.90688	52.35794
1102	1102	258.008577	Shared room	True	False	2.0	False	0	0	8.0	90.0	1	0.280204	0.516217	533.962653	28.273677	807.492307	56.267226	4.89295	52.37575

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample